package com.css.bjdt_report.cell.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.css.bjdt_report.cell.entity.CellData;
import com.css.bjdt_report.util.MyBatisDao;

@MyBatisDao
public interface CellDataDao {

	public List<CellData> selectCellData(@Param("annualId")String annualId, @Param("dzzId")String dzzId, @Param("templateId")String templateId, @Param("cellIds")String[] cellIds, @Param("sumStatus")String sumStatus);

	public int countCellDataByTemplate(@Param("annualId")String annualId, @Param("dzzId")String dzzId, @Param("cellId")String cellId);

	public String sumCellData(@Param("annualId")String annualId, @Param("cellId")String cellId, @Param("dzzIds")String[] dzzIds);

	public void insertCellData(@Param("annualId") String annualId, @Param("cellData") CellData cellData);

	public void deleteCellDataByCellType(@Param("annualId") String annualId, @Param("dzzId") String dzzId);

	public void deleteCellDataByDzzIdAndTemplateId(@Param("annualId") String annualId, @Param("dzzId") String dzzId, @Param("templateId") String templateId);

	public void deleteCellDataByDzzIdAndTemplateIdSummary(@Param("annualId") String annualId, @Param("dzzId") String dzzId, @Param("templateId") String templateId);

	public void deleteSumCellDataByDzzIdAndTemplateId(@Param("annualId") String annualId, @Param("dzzId") String dzzId, @Param("templateId") String templateId);

	public void deleteCellDataByDzzId(@Param("annualId") String annualId, @Param("dzzId") String dzzId);

}
